{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["RE 75-1","Instructions","Guidance&Regulations","Checklist","\"Buy America\"Guidance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RE 75-1","index":0,"n_rows":225,"n_cols":256,"rows_kept":225,"cut":false,"hidden":false,"merged":[[205,8,205,12],[212,5,212,12],[200,2,200,4],[201,8,201,12],[203,8,203,12],[1,19,1,24],[189,3,189,11],[4,10,4,12],[5,10,5,12],[7,10,7,12],[191,4,191,16],[3,6,3,8],[4,6,4,8],[6,6,6,12],[5,6,5,8],[7,6,7,8],[9,10,9,12],[122,8,122,10],[167,15,167,19],[174,0,174,4],[168,15,168,19],[0,4,1,12],[133,19,133,27],[166,15,166,26],[220,5,220,12],[224,5,224,12],[216,5,216,12],[219,6,219,10],[223,6,223,12],[214,5,214,12],[9,0,9,2],[5,0,5,2],[9,6,9,8],[106,8,106,10],[121,8,121,10],[8,6,8,8],[12,0,12,12],[8,0,8,2],[207,8,207,12],[193,0,193,12],[195,2,198,4],[197,8,197,12],[199,8,199,12],[125,0,125,13],[130,0,130,12],[170,0,170,4],[195,8,195,12],[172,0,172,4],[130,160,130,190],[130,192,130,222],[130,224,130,254],[132,44,132,55],[132,56,132,60],[132,64,132,75],[130,64,130,94],[130,96,130,126],[130,128,130,158],[132,184,132,188],[132,204,132,215],[132,216,132,220],[132,224,132,235],[132,236,132,247],[132,248,132,252],[133,44,133,55],[132,140,132,151],[132,152,132,156],[132,160,132,171],[132,172,132,183],[132,192,132,203],[132,76,132,87],[132,88,132,92],[132,96,132,107],[132,108,132,119],[132,120,132,124],[132,128,132,139],[133,248,133,252],[134,44,134,55],[134,56,134,60],[134,64,134,75],[134,76,134,87],[134,88,134,92],[133,184,133,188],[133,192,133,203],[133,204,133,215],[133,216,133,220],[133,224,133,235],[133,236,133,247],[133,120,133,124],[133,128,133,139],[133,140,133,151],[133,152,133,156],[133,160,133,171],[133,172,133,183],[133,56,133,60],[133,64,133,75],[133,76,133,87],[133,88,133,92],[133,96,133,107],[133,108,133,119],[134,224,134,235],[134,236,134,247],[134,248,134,252],[135,44,135,55],[135,56,135,60],[135,64,135,75],[134,160,134,171],[134,172,134,183],[134,184,134,188],[134,192,134,203],[134,204,134,215],[134,216,134,220],[134,96,134,107],[134,108,134,119],[134,120,134,124],[134,128,134,139],[134,140,134,151],[134,152,134,156],[135,204,135,215],[135,216,135,220],[135,224,135,235],[135,236,135,247],[135,248,135,252],[136,44,136,55],[135,140,135,151],[135,152,135,156],[135,160,135,171],[135,172,135,183],[135,184,135,188],[135,192,135,203],[135,76,135,87],[135,88,135,92],[135,96,135,107],[135,108,135,119],[135,120,135,124],[135,128,135,139],[136,248,136,252],[137,44,137,55],[137,56,137,60],[137,64,137,75],[137,76,137,87],[137,88,137,92],[136,184,136,188],[136,192,136,203],[136,204,136,215],[136,216,136,220],[136,224,136,235],[136,236,136,247],[136,120,136,124],[136,128,136,139],[136,140,136,151],[136,152,136,156],[136,160,136,171],[136,172,136,183],[136,56,136,60],[136,64,136,75],[136,76,136,87],[136,88,136,92],[136,96,136,107],[136,108,136,119],[137,224,137,235],[137,236,137,247],[137,248,137,252],[138,44,138,55],[138,56,138,60],[138,64,138,75],[137,160,137,171],[137,172,137,183],[137,184,137,188],[137,192,137,203],[137,204,137,215],[137,216,137,220],[137,96,137,107],[137,108,137,119],[137,120,137,124],[137,128,137,139],[137,140,137,151],[137,152,137,156],[138,204,138,215],[138,216,138,220],[138,224,138,235],[138,236,138,247],[138,248,138,252],[139,44,139,55],[138,140,138,151],[138,152,138,156],[138,160,138,171],[138,172,138,183],[138,184,138,188],[138,192,138,203],[138,76,138,87],[138,88,138,92],[138,96,138,107],[138,108,138,119],[138,120,138,124],[138,128,138,139],[139,248,139,252],[140,44,140,55],[140,56,140,60],[140,64,140,75],[140,76,140,87],[140,88,140,92],[139,184,139,188],[139,192,139,203],[139,204,139,215],[139,216,139,220],[139,224,139,235],[139,236,139,247],[139,120,139,124],[139,128,139,139],[139,140,139,151],[139,152,139,156],[139,160,139,171],[139,172,139,183],[139,56,139,60],[139,64,139,75],[139,76,139,87],[139,88,139,92],[139,96,139,107],[139,108,139,119],[140,224,140,235],[140,236,140,247],[140,248,140,252],[141,44,141,55],[141,56,141,60],[141,64,141,75],[140,160,140,171],[140,172,140,183],[140,184,140,188],[140,192,140,203],[140,204,140,215],[140,216,140,220],[140,96,140,107],[140,108,140,119],[140,120,140,124],[140,128,140,139],[140,140,140,151],[140,152,140,156],[141,204,141,215],[141,216,141,220],[141,224,141,235],[141,236,141,247],[141,248,141,252],[142,44,142,55],[141,140,141,151],[141,152,141,156],[141,160,141,171],[141,172,141,183],[141,184,141,188],[141,192,141,203],[141,76,141,87],[141,88,141,92],[141,96,141,107],[141,108,141,119],[141,120,141,124],[141,128,141,139],[142,248,142,252],[143,44,143,55],[143,56,143,60],[143,64,143,75],[143,76,143,87],[143,88,143,92],[142,184,142,188],[142,192,142,203],[142,204,142,215],[142,216,142,220],[142,224,142,235],[142,236,142,247],[142,120,142,124],[142,128,142,139],[142,140,142,151],[142,152,142,156],[142,160,142,171],[142,172,142,183],[142,56,142,60],[142,64,142,75],[142,76,142,87],[142,88,142,92],[142,96,142,107],[142,108,142,119],[143,224,143,235],[143,236,143,247],[143,248,143,252],[144,44,144,55],[144,56,144,60],[144,64,144,75],[143,160,143,171],[143,172,143,183],[143,184,143,188],[143,192,143,203],[143,204,143,215],[143,216,143,220],[143,96,143,107],[143,108,143,119],[143,120,143,124],[143,128,143,139],[143,140,143,151],[143,152,143,156],[144,204,144,215],[144,216,144,220],[144,224,144,235],[144,236,144,247],[144,248,144,252],[145,44,145,55],[144,140,144,151],[144,152,144,156],[144,160,144,171],[144,172,144,183],[144,184,144,188],[144,192,144,203],[144,76,144,87],[144,88,144,92],[144,96,144,107],[144,108,144,119],[144,120,144,124],[144,128,144,139],[145,248,145,252],[146,44,146,55],[146,56,146,60],[146,64,146,75],[146,76,146,87],[146,88,146,92],[145,184,145,188],[145,192,145,203],[145,204,145,215],[145,216,145,220],[145,224,145,235],[145,236,145,247],[145,120,145,124],[145,128,145,139],[145,140,145,151],[145,152,145,156],[145,160,145,171],[145,172,145,183],[145,56,145,60],[145,64,145,75],[145,76,145,87],[145,88,145,92],[145,96,145,107],[145,108,145,119],[146,224,146,235],[146,236,146,247],[146,248,146,252],[147,44,147,55],[147,56,147,60],[147,64,147,75],[146,160,146,171],[146,172,146,183],[146,184,146,188],[146,192,146,203],[146,204,146,215],[146,216,146,220],[146,96,146,107],[146,108,146,119],[146,120,146,124],[146,128,146,139],[146,140,146,151],[146,152,146,156],[147,204,147,215],[147,216,147,220],[147,224,147,235],[147,236,147,247],[147,248,147,252],[148,44,148,55],[147,140,147,151],[147,152,147,156],[147,160,147,171],[147,172,147,183],[147,184,147,188],[147,192,147,203],[147,76,147,87],[147,88,147,92],[147,96,147,107],[147,108,147,119],[147,120,147,124],[147,128,147,139],[148,248,148,252],[149,44,149,55],[149,56,149,60],[149,64,149,75],[149,76,149,87],[149,88,149,92],[148,184,148,188],[148,192,148,203],[148,204,148,215],[148,216,148,220],[148,224,148,235],[148,236,148,247],[148,120,148,124],[148,128,148,139],[148,140,148,151],[148,152,148,156],[148,160,148,171],[148,172,148,183],[148,56,148,60],[148,64,148,75],[148,76,148,87],[148,88,148,92],[148,96,148,107],[148,108,148,119],[149,224,149,235],[149,236,149,247],[149,248,149,252],[150,44,150,55],[150,56,150,60],[150,64,150,75],[149,160,149,171],[149,172,149,183],[149,184,149,188],[149,192,149,203],[149,204,149,215],[149,216,149,220],[149,96,149,107],[149,108,149,119],[149,120,149,124],[149,128,149,139],[149,140,149,151],[149,152,149,156],[150,204,150,215],[150,216,150,220],[150,224,150,235],[150,236,150,247],[150,248,150,252],[151,44,151,55],[150,140,150,151],[150,152,150,156],[150,160,150,171],[150,172,150,183],[150,184,150,188],[150,192,150,203],[150,76,150,87],[150,88,150,92],[150,96,150,107],[150,108,150,119],[150,120,150,124],[150,128,150,139],[151,248,151,252],[152,44,152,55],[152,56,152,60],[152,64,152,75],[152,76,152,87],[152,88,152,92],[151,184,151,188],[151,192,151,203],[151,204,151,215],[151,216,151,220],[151,224,151,235],[151,236,151,247],[151,120,151,124],[151,128,151,139],[151,140,151,151],[151,152,151,156],[151,160,151,171],[151,172,151,183],[151,56,151,60],[151,64,151,75],[151,76,151,87],[151,88,151,92],[151,96,151,107],[151,108,151,119],[152,224,152,235],[152,236,152,247],[152,248,152,252],[153,44,153,55],[153,56,153,60],[153,64,153,75],[152,160,152,171],[152,172,152,183],[152,184,152,188],[152,192,152,203],[152,204,152,215],[152,216,152,220],[152,96,152,107],[152,108,152,119],[152,120,152,124],[152,128,152,139],[152,140,152,151],[152,152,152,156],[153,204,153,215],[153,216,153,220],[153,224,153,235],[153,236,153,247],[153,248,153,252],[154,44,154,55],[153,140,153,151],[153,152,153,156],[153,160,153,171],[153,172,153,183],[153,184,153,188],[153,192,153,203],[153,76,153,87],[153,88,153,92],[153,96,153,107],[153,108,153,119],[153,120,153,124],[153,128,153,139],[154,248,154,252],[155,44,155,55],[155,56,155,60],[155,64,155,75],[155,76,155,87],[155,88,155,92],[154,184,154,188],[154,192,154,203],[154,204,154,215],[154,216,154,220],[154,224,154,235],[154,236,154,247],[154,120,154,124],[154,128,154,139],[154,140,154,151],[154,152,154,156],[154,160,154,171],[154,172,154,183],[154,56,154,60],[154,64,154,75],[154,76,154,87],[154,88,154,92],[154,96,154,107],[154,108,154,119],[155,224,155,235],[155,236,155,247],[155,248,155,252],[156,44,156,55],[156,56,156,60],[156,64,156,75],[155,160,155,171],[155,172,155,183],[155,184,155,188],[155,192,155,203],[155,204,155,215],[155,216,155,220],[155,96,155,107],[155,108,155,119],[155,120,155,124],[155,128,155,139],[155,140,155,151],[155,152,155,156],[157,108,157,119],[156,204,156,215],[156,216,156,220],[156,224,156,235],[156,236,156,247],[156,248,156,252],[157,44,157,55],[156,140,156,151],[156,152,156,156],[156,160,156,171],[156,172,156,183],[156,184,156,188],[156,192,156,203],[156,76,156,87],[156,88,156,92],[156,96,156,107],[156,108,156,119],[156,120,156,124],[156,128,156,139],[157,248,157,252],[158,56,158,60],[158,88,158,92],[158,120,158,124],[158,152,158,156],[158,184,158,188],[158,216,158,220],[158,248,158,252],[157,184,157,188],[157,192,157,203],[157,204,157,215],[157,216,157,220],[157,224,157,235],[157,236,157,247],[157,120,157,124],[157,128,157,139],[157,140,157,151],[157,152,157,156],[157,160,157,171],[157,172,157,183],[157,56,157,60],[157,64,157,75],[157,76,157,87],[157,88,157,92],[157,96,157,107],[165,239,165,243],[166,32,166,43],[166,44,166,46],[166,47,166,51],[165,143,165,147],[165,160,165,171],[166,64,166,75],[165,172,165,174],[165,175,165,179],[165,192,165,203],[165,204,165,206],[165,79,165,83],[165,96,165,107],[165,108,165,110],[165,111,165,115],[165,128,165,139],[165,140,165,142],[165,47,165,51],[165,64,165,75],[165,76,165,78],[166,76,166,78],[166,79,166,83],[166,96,166,107],[166,108,166,110],[166,111,166,115],[166,128,166,139],[165,207,165,211],[165,224,165,235],[165,236,165,238],[166,204,166,206],[166,207,166,211],[166,224,166,235],[166,236,166,238],[166,239,166,243],[167,140,167,142],[167,160,167,171],[167,172,167,174],[167,175,167,179],[167,192,167,203],[166,140,166,142],[166,143,166,147],[166,160,166,171],[166,172,166,174],[166,175,166,179],[166,192,166,203],[167,239,167,243],[167,204,167,206],[167,207,167,211],[167,224,167,235],[167,236,167,238],[167,143,167,147],[167,32,167,43],[167,44,167,46],[167,47,167,51],[167,64,167,75],[167,76,167,78],[167,79,167,83],[167,96,167,107],[167,108,167,110],[167,111,167,115],[167,128,167,139],[169,108,169,110],[169,111,169,115],[168,204,168,206],[169,128,169,139],[169,140,169,142],[169,143,169,147],[169,160,169,171],[168,128,168,139],[168,32,168,43],[168,44,168,46],[168,47,168,51],[168,76,168,78],[168,79,168,83],[168,96,168,107],[168,108,168,110],[168,111,168,115],[168,140,168,142],[168,207,168,211],[168,224,168,235],[168,236,168,238],[168,239,168,243],[168,143,168,147],[168,160,168,171],[168,172,168,174],[168,175,168,179],[168,192,168,203],[165,32,165,43],[165,44,165,46],[169,64,169,75],[132,0,132,4],[133,0,133,4],[134,0,134,4],[135,0,135,4],[169,15,169,19],[169,32,169,43],[169,44,169,46],[169,47,169,51],[168,64,168,75],[151,0,151,4],[152,0,152,4],[153,0,153,4],[144,0,144,4],[145,0,145,4],[146,0,146,4],[147,0,147,4],[148,0,148,4],[149,0,149,4],[132,6,132,10],[133,6,133,10],[134,6,134,10],[169,236,169,238],[169,239,169,243],[170,15,170,19],[170,32,170,43],[170,44,170,46],[170,47,170,51],[170,64,170,75],[170,76,170,78],[170,204,170,206],[170,79,170,83],[169,172,169,174],[169,175,169,179],[169,192,169,203],[169,204,169,206],[169,207,169,211],[169,224,169,235],[169,76,169,78],[170,207,170,211],[170,160,170,171],[170,172,170,174],[170,175,170,179],[170,192,170,203],[169,79,169,83],[169,96,169,107],[170,236,170,238],[170,239,170,243],[171,32,171,43],[171,44,171,46],[171,47,171,51],[171,111,171,115],[171,128,171,139],[171,140,171,142],[170,143,170,147],[171,64,171,75],[170,96,170,107],[170,108,170,110],[170,111,170,115],[170,128,170,139],[170,140,170,142],[170,224,170,235],[171,224,171,235],[171,236,171,238],[171,239,171,243],[171,204,171,206],[171,207,171,211],[172,15,172,19],[172,32,172,43],[172,44,172,46],[172,47,172,51],[172,111,172,115],[172,128,172,139],[172,192,172,203],[171,160,171,171],[171,172,171,174],[171,175,171,179],[171,192,171,203],[171,76,171,78],[171,79,171,83],[171,96,171,107],[171,108,171,110],[171,143,171,147],[172,140,172,142],[172,64,172,75],[172,76,172,78],[172,79,172,83],[172,96,172,107],[172,108,172,110],[172,207,172,211],[172,204,172,206],[172,143,172,147],[172,160,172,171],[172,172,172,174],[172,175,172,179],[172,224,172,235],[172,236,172,238],[172,239,172,243],[173,204,173,206],[173,207,173,211],[173,224,173,235],[173,236,173,238],[173,239,173,243],[174,15,174,19],[174,32,174,43],[174,44,174,46],[174,47,174,51],[174,111,174,115],[173,140,173,142],[173,143,173,147],[173,160,173,171],[173,172,173,174],[173,175,173,179],[173,192,173,203],[173,76,173,78],[173,79,173,83],[173,96,173,107],[173,108,173,110],[173,15,173,19],[173,32,173,43],[173,44,173,46],[173,47,173,51],[173,111,173,115],[173,64,173,75],[173,128,173,139],[174,239,174,243],[175,15,175,19],[175,32,175,43],[175,44,175,46],[175,47,175,51],[175,64,175,75],[175,172,175,174],[175,175,175,179],[175,192,175,203],[175,204,175,206],[174,204,174,206],[174,207,174,211],[175,128,175,139],[175,140,175,142],[175,143,175,147],[175,160,175,171],[175,207,175,211],[174,160,174,171],[174,172,174,174],[175,79,175,83],[175,96,175,107],[174,64,174,75],[175,224,175,235],[175,236,175,238],[175,239,175,243],[176,15,176,19],[176,44,176,46],[176,47,176,51],[176,76,176,78],[176,79,176,83],[176,108,176,110],[176,111,176,115],[174,76,174,78],[174,79,174,83],[174,96,174,107],[174,224,174,235],[174,236,174,238],[174,108,174,110],[174,128,174,139],[174,140,174,142],[174,143,174,147],[174,175,174,179],[174,192,174,203],[180,178,180,183],[180,210,180,215],[176,140,176,142],[180,242,180,247],[176,143,176,147],[176,172,176,174],[176,175,176,179],[176,204,176,206],[176,207,176,211],[176,236,176,238],[151,6,151,10],[140,6,140,10],[141,6,141,10],[142,6,142,10],[143,6,143,10],[144,6,144,10],[145,6,145,10],[181,210,181,215],[181,242,181,247],[181,18,181,23],[181,50,181,55],[181,82,181,87],[181,114,181,119],[175,108,175,110],[175,111,175,115],[175,76,175,78],[181,146,181,151],[181,178,181,183],[176,239,176,243],[180,18,180,23],[180,50,180,55],[180,82,180,87],[180,114,180,119],[180,146,180,151],[135,6,135,10],[136,6,136,10],[137,6,137,10],[138,6,138,10],[139,6,139,10],[150,0,150,4],[146,6,146,10],[147,6,147,10],[148,6,148,10],[149,6,149,10],[150,6,150,10],[136,0,136,4],[137,0,137,4],[138,0,138,4],[139,0,139,4],[140,0,140,4],[141,0,141,4],[142,0,142,4],[143,0,143,4],[190,0,190,12],[152,6,152,10],[153,6,153,10],[154,6,154,10],[155,6,155,10],[154,0,154,4],[155,0,155,4],[173,0,173,4],[171,0,171,4],[160,0,160,6],[165,0,165,4],[166,0,166,4],[167,0,167,4],[168,0,168,4],[169,0,169,4],[156,6,156,10],[157,6,157,10],[156,0,156,4],[157,0,157,4],[175,0,175,4]]}
["RE 75-1",null,null,null,"Agreement No. and Date (ODOT Use Only):",null,null,null,null,null,null,null,null,null,"Yes","Adams (District 9)","1 & Partial","ADA",9,null,null,null,null,null,null,"Original Estimate"]
["Revised 10/15/18",null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Allen (District 1)","2 & Partial","ALL",1,"Click Here for Instructions",null,null,null,null,null,"Revision #1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ashland (District 3)","3 & Partial","ASD",3,null,null,null,null,null,null,"Revision #2"]
["Utility",null,null,null,null,null,"County (Counties)",null,null,null,null,null,null,null,null,"Ashtabula (District 4)","4 & Partial","ATB",4,null,null,null,null,null,null,"Revision #3"]
["Street Address",null,null,null,null,null,"Route No.",null,null,null,null,null,null,null,null,"Athens (District 10)","5 & Partial","ATH",10,null,null,null,null,null,null,"Revision #4"]
["City, State, Zip",null,null,null,null,null,"Section",null,null,null,null,null,null,null,null,"Auglaize (District 7)","6 & Partial","AUG",7,null,null,null,null,null,null,"Revision #4"]
["Tax ID No.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Belmont (District 11)","7 & Partial","BEL",11]
["Work Order No.",null,null,null,null,null,"PID #",null,null,null,null,null,null,null,null,"Brown (District 9)","8 & Partial","BRO",9]
["Date of Estimate",null,null,null,null,null,"ODOT District",null,null,null,{"$f":"IF(ISBLANK(K4),\"\",VLOOKUP(K4,R:S,2,FALSE))","v":""},null,{"$f":"IF(ISBLANK(M4),\"\",VLOOKUP(M4,R:S,2,FALSE))","v":""},null,null,"Butler (District 8)","9 & Partial","BUT",8]
["Estimate Version",null,null,null,"Original Estimate",null,"Name of Estimate Preparer",null,null,null,null,null,null,null,null,"Carroll (District 11)","10 & Partial","CAR",11,{"$f":"IF(ISBLANK(K10),\"<-- Please enter your name.\",\"\")","v":"<-- Please enter your name."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Champaign (District 7)","11 & Partial","CHP",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clark (District 7)","12 & Partial","CLA",7]
["PRELIMINARY ESTIMATE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clermont (District 8)","13 & Partial","CLE",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinton (District 8)","19 & Partial","CLI",8]
["A. Preliminary Engineering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Columbiana (District 11)","20 & Partial","COL",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coshocton (District 5)","1 & Final","COS",5]
[null,"1. Labor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Crawford (District 3)","2 & Final","CRA",3]
[null,null,"a. Salaries and Wages",null,null,null,null,null,null,null,null,null," ",null,null,"Cuyahoga (District 12)","3 & Final","CUY",12]
[null,null,"b. Fringe Benefits to Labor",null,null,null,null,null,null,null,null,null,null,null,null,"Darke (District 7)","4 & Final","DAR",7]
[null,null,"c. Meals, Lodging and Travel",null,null,null,null,null,null,null,null,null,null,null,null,"Defiance (District 1)","5 & Final","DEF",1]
[null,null,"d. Subconsultant Engineering",null,null,null,null,null,null,null,{"$f":"SUM(I18:I21)","v":0},null,null,null,null,"Delaware (District 6)","6 & Final","DEL",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erie (District 3)","7 & Final","ERI",3]
[null,"2. Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fairfield (District 5)","8 & Final","FAI",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fayette (District 6)","9 & Final","FAY",6]
[null,"3. Transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Franklin (District 6)","10 & Final","FRA",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fulton (District 2)","11 & Final","FUL",2]
[null,"4.  Total Preliminary Engineering",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K25,K23,K21)","v":0},null,null,"Gallia (District 10)","12 & Final","GAL",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geauga (District 12)","13 & Final","GEA",12]
["B.  Right of Way Acquisition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greene (District 8)","14 & Final","GRE",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guernsey (District 5)","15 & Final","GUE",5]
[null,"1. Property Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hamilton (District 8)","16 & Final","HAM",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hancock (District 1)","17 & Final","HAN",1]
[null,"2.  Labor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hardin (District 1)","18 & Final","HAR",1]
[null,null,"a.  Salaries and Wages",null,null,null,null,null,null,null,null,null,null,null,null,"Harrison (District 11)","19 & Final","HAS",11]
[null,null,"b.  Fringe Benefits to Labor",null,null,null,null,null,null,null,null,null,null,null,null,"Henry (District 2)","20 & Final","HEN",2]
[null,null,"c.  Meals, Lodging and Travel",null,null,null,null,null,null,null,null,null,null,null,null,"Highland  (District 9)",null,"HIG",9]
[null,null,"d.  Subcontracted Right of Way Acquisition",null,null,null,null,null,null,null,{"$f":"SUM(I34:I37)","v":0},null,null,null,null,"Hocking (District 10)",null,"HOC",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Holmes (District 11)",null,"HOL",11]
[null,"3.  Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,"Huron (District 3)",null,"HUR",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jackson (District 9)",null,"JAC",9]
[null,"4.  Transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,"Jefferson (District 11)",null,"JEF",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Knox (District 5)",null,"KNO",5]
[null,"5.  Total Property Costs",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K31,K37,K39,K41)","v":0},null,null,"Lake (District 12)",null,"LAK",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lawrence (District 9)",null,"LAW",9]
["C.  Temporary Construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Licking (District 5)",null,"LIC",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Logan (District 7)",null,"LOG",7]
[null,"1.  Labor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Lorain (District 3)",null,"LOR",3]
[null,null,"a. Salaries and Wages",null,null,null,null,null,null,null,null,null,null,null,null,"Lucas (District 2)",null,"LUC",2]
[null,null,"b.  Fringe Benefits to Labor",null,null,null,null,null,null,null,null,null,null,null,null,"Madison (District 6)",null,"MAD",6]
[null,null,"c. Meals, Lodging and Travel",null,null,null,null,null,null,null,null,null,null,null,null,"Mahoning (District 4)",null,"MAH",4]
[null,null,"d. Subcontracted Construction",null,null,null,null,null,null,null,{"$f":"SUM(I48:I51)","v":0},null,null,null,null,"Marion (District 6)",null,"MAR",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medina (District 3)",null,"MED",3]
[null,"2.  Material (Itemized)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Meigs (District 10)",null,"MEG",10]
[null,null,"a.  New Stock Materials",null,null,null,null,null,null,null,null,null,null,null,null,"Mercer (District 7)",null,"MER",7]
[null,null,"b.  Purchased Materials",null,null,null,null,null,null,null,null,null,null,null,null,"Miami (District 7)",null,"MIA",7]
[null,null,"c.  Salvage",null,null,null,null,null,null,null,null,null,null,null,null,"Monroe (District 10)",null,"MOE",10]
[null,null,"d.  Material Handling Rate/Stores (Stock Materials Only)",null,null,null,null,null,null,null,{"$f":"SUM(I54:I57)","v":0},null,null,null,null,"Montgomery (District 7)",null,"MOT",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morgan (District 10)",null,"MRG",10]
[null,"3.  Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,"Morrow (District 6)",null,"MOR",6]
[null,null,"a.  Utility Owned",null,null,null,null,null,null,null,null,null,null,null,null,"Muskingum (District 5)",null,"MUS",5]
[null,null,"b.  Rented",null,null,null,null,null,null,null,{"$f":"SUM(I60:I61)","v":0},null,null,null,null,"Noble (District 10)",null,"NOB",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ottawa (District 2)",null,"OTT",2]
[null,"4.  Total Temporary Construction",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K61,K57,K51)","v":0},null,null,"Paulding (District 1)",null,"PAU",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perry (District 5)",null,"PER",5]
["D.  Permanent Construction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pickaway (District 6)",null,"PIC",6]
[null,"1.  Labor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pike (District 9)",null,"PIK",9]
[null,null,"a. Salaries and Wages",null,null,null,null,null,null,null,null,null,null,null,null,"Portage (District 4)",null,"POR",4]
[null,null,"b.  Fringe Benefits to Labor",null,null,null,null,null,null,null,null,null,null,null,null,"Preble (District 8)",null,"PRE",8]
[null,null,"c. Meals, Lodging and Travel",null,null,null,null,null,null,null,null,null,null,null,null,"Putnam (District 1)",null,"PUT",1]
[null,null,"d. Subcontracted Construction",null,null,null,null,null,null,null,{"$f":"SUM(I67:I70)","v":0},null,null,null,null,"Richland (District 3)",null,"RIC",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ross (District 9)",null,"ROS",9]
[null,"2.  Material (Itemized)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sandusky (District 2)",null,"SAN",2]
[null,null,"a.  New Stock Materials",null,null,null,null,null,null,null,null,null,null,null,null,"Scioto (District 9)",null,"SCI",9]
[null,null,"b.  Purchased Materials",null,null,null,null,null,null,null,null,null,null,null,null,"Seneca (District 2)",null,"SEN",2]
[null,null,"c.  Salvage",null,null,null,null,null,null,null,null,null,null,null,null,"Shelby (District 7)",null,"SHE",7]
[null,null,"d.  Material Handling Rate/Stores (Stock Materials Only)",null,null,null,null,null,null,null,{"$f":"SUM(I73:I76)","v":0},null,null,null,null,"Stark (District 4)",null,"STA",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Wide (District Multiple)",null,"STW","Multiple"]
[null,"3.  Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,"Summit (District 4)",null,"SUM",4]
[null,null,"a.  Utility Owned",null,null,null,null,null,null,null,null,null,null,null,null,"Trumbull (District 4)",null,"TRU",4]
[null,null,"b.  Rented",null,null,null,null,null,null,null,{"$f":"SUM(I79:I80)","v":0},null,null,null,null,"Tuscarawas (District 11)",null,"TUS",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Union (District 6)",null,"UNI",6]
[null,"4.  Total Permanent Construction",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K70,K76,K80)","v":0},null,null,"Van Wert (District 1)",null,"VAN",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vinton (District 10)",null,"VIN",10]
["E.  Construction Engineering and Inspection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warren (District 8)",null,"WAR",8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington (District 10)",null,"WAS",10]
[null,"1. Labor",null,null,null,null,null,null,null,null,null,null,null,null,null,"Wayne (District 3)",null,"WAY",3]
[null,null,"a. Salaries and Wages",null,null,null,null,null,null,null,null,null,null,null,null,"Williams (District 2)",null,"WIL",2]
[null,null,"b.  Fringe Benefits to Labor",null,null,null,null,null,null,null,null,null,null,null,null,"Wood (District 2)",null,"WOO",2]
[null,null,"c. Meals, Lodging and Travel",null,null,null,null,null,null,null,null,null,null,null,null,"Wyandot (District 1)",null,"WYA",1]
[null,null,"d. Subconsultant Engineering",null,null,null,null,null,null,null,{"$f":"SUM(I87:I90)","v":0}]
[]
[null,"2. Supplies"]
[]
[null,"3. Transportation"]
[]
[null,"4.  Total Construction Engineering",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K90,K92,K94)","v":0}]
[]
["F.  Accounting/Billing"]
[]
[null,"1.  Labor"]
[null,null,"a. Salaries and Wages"]
[null,null,"b.  Fringe Benefits to Labor"]
[]
[null,"4.  Total Accounting/Billing",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(I101:I102)","v":0}]
[]
["G.  General and Administrative Overhead"]
[]
[]
[]
["Allowable G&A Overhead in Accordance with 23 CFR 645.117(d) and 48 CFR 31."]
[]
["H.  Total Costs",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M27,M43,M63,M82,M96,M104,M110)","v":0}]
[]
["I.  Less Betterment (Must be a credit balance)"]
[]
["J.  Less Accrued Depreciation (Must be a credit balance)"]
[]
["K.  Total Allowable Actual Cost per 23 CFR 645.117",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M112,M114,M116)","v":0}]
[]
[null,null,null,null,"Total Units Relocated"]
[null,null,null,null,"Total Units Reimbursable to Utility"]
[null,null,null,null,"Percentage Utility Participation",null,{"$f":"ROUND(IF(ISBLANK(G120),1,1-G121/G120),4)","v":1},null,"Estimated Utility Participation",null,null,null,{"$f":"IF(ISERROR(G123),\"\",IF(G121>G120,\"error in cell G121\",(M118*G122)))","v":0}]
[null,null,null,null,"Percentage ODOT Participation",null,{"$f":"1-G122","v":0},null,"Estimated ODOT Partcipation",null,null,null,{"$f":"IF(ISERROR(G123),\"\",IF(G121>G120,\"error in cell G121\",(M118*G123)))","v":0}]
[]
[]
[{"$f":"CONCATENATE(E4,\" - \",K4,\" - \",K5,\" - \",K6,\" - \",E10,\" as prepared by \",K10,\".\")","v":" -  -  -  - Original Estimate as prepared by ."}]
[]
[null,null,null,null,null,null,null,null,"Yes",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No"]
["1.  Will the Utility subcontract any portion of the relocation?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<== To enter a check into the box, type a lower-case \"a.\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<==typing a lower-case \"a\" will put a check in the box."]
[]
["If yes, please complete the following and attach estimates provided by each listed subcontractor.  If the subcontractor is under continuing contract or agreement with the utility, please provide the agreement to support the estimated costs."]
[]
["Name of Subconsultant/Subcontractor",null,null,null,null,null,"Type of Work Performed",null,null,null,null,null,"Estimated Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<==Enter data in descending order of cost."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Top"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M134:M158)","v":0}]
[null,null,null,null,null,null,null,null,"Yes",null,"No"]
["2.  Does this estimate include the use of overtime labor for the utility or any subcontractor?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<== To enter a check into the box, type a lower-case \"a.\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<==typing a lower-case \"a\" will put a check in the box."]
[]
["If yes, please detail the number of estimated overtime hours and associated overtime premium costs for the utility and each vendor."]
[]
["Utility/Subcontractor",null,null,null,null,null,null,null,"OT Hours",null,"OT Premium Costs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<==List any overtime estimated by the utility first.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<==Should include the overtime costs of the utility, if applicable."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Top",null,null,null,"Back to Top"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I167:I176)","v":0},null,{"$f":"SUM(K167:K176)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["I hereby acknowledge that State or Federal funds will be used to reimburse the utility for the allowable costs of the utility relocation listed above.  \n\nAccordingly, I hereby certify that the costs used to create this estimate are in accordance with the executed Master Utility Reimbursement Agreement between ODOT and the Utility, all applicable laws, regulations and policies, including but not limited to 23 CFR 645, 48 CFR 31, the Buy America requirements contained in 23 USC 313 and 23 CFR 635.410, the ODOT Office of Real Estate Utilities Manual, and other applicable Federal, State, and ODOT regulations or policies.  I also certify that this estimate contains no contingencies or premium labor costs unless clearly proposed in this estimate. \n\nI further acknowledge that costs submitted for reimbursement that do not comply with the above guidance will not be reimbursed by ODOT.\n\n"]
[null,null,null,null,"By checking box, utility agrees to conform to the \"Buy America\" policy.  If box is unchecked, ODOT cannot process utility billing for final payment. "]
[]
["\"Buy America\" requires: \"STEEL AND IRON PRODUCTS MADE IN THE UNITED STATES\".  Furnish steel and iron products that are made in the United States according to the applicable provisions of Federal regulations stated in CFR 635.410.  \"United States\" means the United States of America and includes all territory, continental or insular, subject to jurisdiction of the United States.\n     Federal Requirements:  All steel or iron products incorporated permanently into the utility relocation work must be made of steel or iron produced in the United States and all subsequence manufacturing must be performed in the United States.  Manufacturing is any process that modifies the chemical content; physical shape or size; or final finish of a product.  Manufacturing begins with the initial melting and mixing, and continues through the bending and coating stages.  If a domestic product is taken out of the United States for any process, it becomes a foreign source material and is not acceptable.\n     Proof of Domestic Origin:  Furnish documentation to the ODOT District Utility Coordinator showing the domestic origin of all steel and iron products covered by this section before they are incorporated into the utility relocation work. If \"Buy America\" regulations are not adhered to, then any relocation work will not be reimbursed."]
[]
[null,null,"Note:  The completed Checklist and other required materials should accompany this estimate when sent to the ODOT District office.",null,null,null,null,null,"(Utility Name - Print or Type)"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(E4),\"\",E4)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to Top"]
[null,null,null,null,null,null,null,null,"(Print or Type)"]
[null,null,"Go To Checklist Tab"]
[null,null,null,null,null,null,"Name"]
[]
[null,null,null,null,null,null,"Title"]
[]
[null,null,null,null,null,null,"Phone #"]
[]
[null,null,null,null,null,null,"Email"]
[]
[]
[]
[null,null,null,null,{"$f":"TODAY()","v":"2019-09-27"}]
[null,null,null,null,null,"Authorizing Signature"]
[]
[null,null,null,null,null,"(Please print and submit with other requested documentation)"]
[]
[null,null,null,null,null,"For ODOT Use Only"]
[]
[]
[]
[null,null,null,null,null,"Print Name (ODOT Authorization)                             Date"]
[]
[]
[]
[null,null,null,null,null,"Signature of Acceptance of Estimate by Authorized ODOT Personnel"]

{"sheet":"Instructions","index":1,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Prepared by the ODOT Office of Audits - Last updated on 8/20/2008."]
[]
["The following provides guidance on the proper completion of ODOT Utilities form RE 75-1."]
[]
["All cells in gray may be edited by the user.  All other cells contain formulas that cannot be edited.  Do not alter any formulas contained in this spreadsheet."]
["Parts of this spreadsheet contain \"cell validation,\" which prevents the user from entering invalid data.  For example, salvage credits will only accept negative (credit) values."]
[]
["The following provides explanations as to the proper entry of data and some of the validations to facilitate proper entry of data:"]
[]
["Field","Comment(s)"]
["Tax ID No.","Enter the Tax ID Number of the Utility.  Tax ID Numbers contain nine (9) digits.  You may include or exclude the dash after the second digit."]
["Work Order No.","This is the the project identification number assigned by the Utility for this project."]
["Estimate Version","Select from the drop-down menu.  It is classified by \"original estimate,\" or \"revision #x.\""]
["County","This is the 3-letter ODOT abbreviation for the County in which the project took place.  Select from the drop-down menu.  Cell K-9 will \"auto populate\" the appropriate district based upon the County chosen.  "]
["County (2)","If the project took place in two counties, this cell is available if necessary."]
["PID","Enter the four or five-digit ODOT PID (Project Identification Number)."]
["Salaries and Wages","Enter the amount of wages paid to employees of the Utility for this cost category."]
["Fringe Benefits","Enter the Fringe Benefit costs paid to or on behalf of the associated labor.  If it is the policy of the utility to apply \"loaded\" wage rates, in that fringe benefits and/or other indirect costs are include in the rates claimed on the relocation, it is permissible to include all of these costs under \"salaries and wages.\"  If the firm claims actual pay rates, fringes must be included here."]
["Meals, Lodging and Travel","Enter the meal, lodging and travel costs (vehicle mileage/airfare) associated with employees working in the cost category.  There should be no costs for subconsultants here."]
["Subconsultant Engineering","Enter the total cost of all subconsultants used in this cost category, including direct labor, overhead, non-salary direct costs, and any other costs incurred by the subconsultant.  No costs of the Utility should be shown here."]
["Supplies","Enter any supply costs incurred by the Utility used in this cost category."]
["Transportation","Enter any transportation costs incurred by the Utility used in this cost category that have not already been claimed under Meals, Lodging, and Travel, such as necessary vehicle rentals or allowable vehicle mileage costs."]
["Property Costs","Include all property purchase Right-of-Way costs not included in other Right-of-Way cost categories."]
["Subcontracted Engineering","Enter the total cost of all subcontractors used in this cost category, including direct labor, overhead, non-salary direct costs, and any other costs incurred by the subconsultant.  No costs of the Utility should be shown here."]
["New Stock Materials","Enter the total stock value of all materials used on the project from the stock of the Utility.  All materials should be billed at actual cost to the Utility and contain no markups."]
["Purchased Materials","Enter the total value of all materials purchased and shipped to the project site, including shipping costs.  Amounts estimated for gas loss (if applicable) may be included here."]
["Salvage","Enter the total amount credited to the project for material salvaged in this cost category.  The spreadsheet will only accept negative amounts.  You may also leave the cell blank."]
["Material Handling","The Utility has the option to charge its \"stores\" rate for stock materials or 5%, per Federal guidelines.  Stores may not be applied to materials purchased and shipped to the job site."]
["Owned Equipment","Enter the actual cost of equipment used on the project owned by the Utility, without markup."]
["Rented Equipment","Enter the actual cost of equipment used on the project rented by the Utility."]
["G&A Overhead Rate","Enter the General and Administrative Overhead costs allocable to the project.  Each utility has its own title for these costs (e.g. A&G, SG&A, overhead, etc.).  The general premise is that G&A allows the utility to recover indirect costs incurred by the utility in the overall management of the business segment."]
["Total Costs","This cell auto-calculates the total of all costs represented on the spreadsheet."]
["Betterments","Enter any betterments to the facility that are creditable to the project.  This cell only accepts credits."]
["Accrued Depreciation","Enter any accrued depreciation creditable to the project.  This cell only accepts credits."]
["Total Units Relocated","Enter the total number of existing units relocated on the project.  This may be represented in any units agreed to between ODOT and the Utility, such as poles, linear feet, etc."]
["Total Units Reimbursable","Enter the total number of existing units relocated that are reimbursable to the Utility, as agreed to between ODOT and the Utility.  The number of reimbursable units cannot exceed the total number of units relocated."]
["Amount Due Utility","This cell auto-calculates the total amount reimbursable to the Utility, as represented on the spreadsheet."]

{"sheet":"Guidance&Regulations","index":2,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["The following regulations are required on utility relocation projects.  You may click on the text to link to the appropriate website."]
[]
["23 CFR 645: Utilities - Specifically, 645.117 addresses reimbursement of claimed relocation costs."]
[]
["48 CFR 31 (FAR Part 31): Contract Cost Principles - Addresses the allowability of costs included in overhead (indirect costs).  Note:  Certain costs cannot be claimed on Federal-Aid contracts and must be excluded from overhead."]
[]
["ODOT Office of Utilities Real Estate Manual - Addresses programmatic as well as billing issues."]
[]
["ODOT Audit Policies and Guidance."]
[]
["Other Helpful Guidance / Websites"]
[]
["48 CFR 22.103: Labor Policies (Overtime)"]
[]
["DCAAP 7641.90: Information for Contractors"]
[]
["PUCO"]
[]
["Federal Energy Regulatory Commission"]
[]
["Federal-Aid Policy Guide 645: Utilities"]

{"sheet":"Checklist","index":3,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[[2,0,2,12],[4,0,4,12],[8,0,8,12],[6,0,6,12]]}
["Rev 12/08"]
[]
["Checklist for Utility Relocation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Go Back to the Estimate (RE 75-1)"]
["Plans & Estimate Including Supporting Data"]
[]
[{"$f":"'RE 75-1'!A126:N126","v":" -  -  -  - Original Estimate as prepared by ."}]
[]
["Please complete and return this checklist along with the Preliminary Estimate and other necessary documents."]
[]
[null,"Item A. Preliminary Engineering"]
[]
[null,null,null,null,"Use of Consultants Services - Copy of Approved Contract with Rates",null,null,null,null,null,null,null,null,"<===You may enter a check in the box by typing the letter \"a.\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Checks may also be entered manually after printing."]
[null,"Item B.  R/W Acquisition"]
[]
[null,null,null,null,"Copy of Property Rights"]
[]
[null,null,null,null,"Use of Consultant Services - Copy of Approved Contract with Rates"]
[]
[null,"Item C.  Temporary Construction"]
[]
[null,null,"Use of Contract Forces - Copy of Approved Continuing Contract or Bid Solicitation"]
[]
[null,null,null,null,null,"Construction",null,null,null,"Tree Trimming"]
[]
[null,null,null,null,"List of Materials to be Installed, Removed, or Abandoned"]
[]
[null,null,null,null,"Salvage Credit Breakdown",null,null,null,null,"Pole Count List"]
[]
[null,null,null,null,"Rental equipment - Copy of Approved Continuing Contract or Bid Solicitation"]
[]
[null,"Item D.  Permanent Construction"]
[]
[null,null,"Use of Contract Forces - Copy of Approved Continuing Contract or Bid Solicitation"]
[]
[null,null,null,null,null,"Construction",null,null,null,"Tree Trimming"]
[]
[null,null,null,null,"List of Materials to be Installed, Removed, or Abandoned"]
[]
[null,null,null,null,"Salvage Credit Breakdown",null,null,null,null,"Pole Count List"]
[]
[null,null,null,null,"Rental equipment - Copy of Approved Continuing Contract or Bid Solicitation"]
[]
[null,"Item E.  Construction Engineering Inspection"]
[]
[null,null,null,null,"Use of Consultant Services - Copy of Approved Contract with Rates"]
[]
[null,"Item G.  Administration, Indirect Overhead and Supervision"]
[]
[null,null,null,null,"Overhead Rate Schedule - Supplied Annually to Central Office Utilities"]
[]
[null,"Item H.  Betterment"]
[]
[null,null,null,null,"Betterment Credit Breakdown"]

{"sheet":"\"Buy America\"Guidance","index":4,"n_rows":114,"n_cols":2,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
["THE OHIO DEPARTMENT OF TRANSPORTATION UTILITY GUIDELINES FOR MEETING FHWA’S “BUY AMERICA”  REGULATIONS ASSOCIATED WITH A UTILITY’S RELOCATION REIMBURSEMENT"]
[]
[1,"Introduction"]
[]
["The “Buy America” regulation applies to the Ohio Department of Transportation’s Master Utility Reimbursement Agreement (MURA) and  requires that all materials that contain more than 90% steel or iron and are used by a utility in its compensable relocation have to be manufactured in America."]
[]
["Implementation of FHWA’s MAP-21 has broadened how the “Buy America” regulation is applied to federally funded transportation projects.  MAP-21 requires that all aspects of a highway construction project (as defined by the project’s NEPA decision document) comply with “Buy America” if any federal highway funds are obligated to the project on or after October 1, 2012."]
[]
["The Ohio Department of Transportation (ODOT), in cooperation with the Federal Highway Administration (FHWA), Ohio Division, has developed guidelines for the implementation of, and conformance with, the “Buy America” provisions, as established in 23 USC – 313 and applicable regulations, including 23 CFR – 635.410 and FHWA guidance.  These guidelines are to be used by utilities for the purpose of clarifying and defining “Buy America” requirements for utility reimbursement for a utility relocation associated with an ODOT highway project.  The use of these guidelines is strictly limited to utilities and will not affect or modify how ODOT and a Local Public Agency (LPA ) apply “Buy America” requirements to transportation materials."]
[]
["The guidelines set forth in this document are applicable and relevant to all federally funded transportation projects when FHWA is determined to be the lead federal agency.  Further, all contracts that are required to implement the federally funded transportation project must comply with “Buy America”.  “Contract” shall be defined as ODOT’s Master Utility Reimbursement Agreement (MURA) that is needed in order to reimburse a utility and necessary to implement a project that is eligible for federal highway funds."]
[]
["These guidelines are intended to supplement and be implemented with the guidance issued by the U.S. Department of Transportation, through the Federal Highway Administration, Ohio Division, on December 20, 2012 (http://www.fhwa.dot.gov/construction/contracts/121220.cfm), December 21,2012 (http://www.fhwa.dot.gov/construction/contracts/121221.cfm), and July 12, 2013 (http://www.fhwa.dot.gov/construction/contracts/130711)."]
[]
[2,"When Do “Buy America” Requirements Apply?"]
[]
["The Ohio Department of Transportation will implement the “Buy America” requirements when utility relocation/reimbursement activities, required by transportation projects, are funded under Title 23 of the US Code."]
[]
[2.1,"Materials"]
[]
["For utilities, the following materials, when comprised of more than 90% steel or iron, are subject to “Buy America”:"]
[]
["·       Raw steel and iron products"]
["·       Mast arms, poles and cross arms, standards, trusses, or supporting              structural members for signs, luminaries, or traffic control systems"]
["·       Steel transmission or distribution pole structures and lattice towers, including girders used to comprise transmission towers and stand-alone platforms"]
["·       Pipe, grates and valves"]
["·       High-strength bolts, anchor bolts and anchor rods"]
["·       Rebar and other reinforcing iron/steel for cast-in-place installations"]
["·       Conduit and ducting"]
["·       Manhole covers, risers and rims"]
["·       Rebar and other reinforcing iron/steel used in concrete transmission or distribution pole structures or any prefabricated concrete vaults or similar concrete structures"]
[]
["ODOT intends to utilize these definitions and documented decisions to provide clarity and to assist utility service providers as they strive to develop internal processes to discern and track materials that are subject to “Buy America” as the practical application of “Buy America” in the field."]
[]
["ODOT will periodically review Bills of Materials for utility reimbursement projects and determine whether the categories described above adequately result in certification of compliance with “Buy America”.  These periodic reviews may result in the addition of categories that are not currently listed in Section 2.1."]
[]
["The following definitions of materials that are permanently incorporated into the utility relocation and are subject to “Buy America”, apply to the utility’s:"]
[]
["·       Anchor Rods, Anchor & High-Strength Bolts – Anchor and high-strength bolts will be distinguished in one of three methods to be selected, and consistently applied, by the utility owner:"]
[1,"The utility owner may specifically identify anchor and high-strength bolts in the specifications or plans as necessary for the safe and functional design of the utility relocation.  If a bolt is not identified as anchor or high- strength, it will be concluded that the design did not require that level of performance, and the supplied bolt is, therefore, not subject to “Buy America”."]
[2,"The utility owner may identify anchor and high-strength bolts through the application of a strength rating.  Any bolt possessing a yield strength of fifty-thousand pounds per square inch (50ksi) or greater will be considered an anchor or high-strength bolt."]
[3,"The utility owner may identify anchor and high-strength bolts through the application of a weight measurement.  Any bolt possessing a weight of fifteen pounds (15lbs) or greater will be considered an anchor or high-strength bolt."]
["·       Girders – A load bearing beam or strut commonly taking the cross-sectional shape of a circle, square, rectangle, or an I, C, L or Z section, and assembled for the purpose of creating lattice towers, stand-alone platforms or transmission towers."]
["·       Lattice Towers – A structure that is compiled of girders and is typically used in series to support conductor cables."]
["·       Stand-Alone Platforms – A structure that is compiled of girders and is used to permanently hold or support large equipment."]
["·       Permanent Installation – The final location and final installation of the materials as defined on the plans or in specifications.  No further adjustments or relocations are necessary to accommodate the final transportation project improvements."]
[]
["When utility relocation is partially reimbursable, all materials that are not otherwise excluded in Section 3 and are included within ODOT’s Master Utility Reimbursement Agreement for the reimbursable utility relocation, will be subject to “Buy America”. "]
[]
["All betterment materials, as defined below, are subject to “Buy America” requirements if the work is included with the Master Utility Reimbursement Agreement and performed under the same highway project contract that includes work eligible for Federal-Aid.  Betterments are defined to be any upgrading of the utility facility being relocated that is not attributable to the highway construction and is made solely for the benefit of and at the election of the utility (23CFR – 645.105).  As such, betterment is not eligible for Federal-Aid."]
[]
[2.2000000000000002,"Acceptable us of Non-Domestic Materials"]
[]
["FHWA and ODOT recognize that there are instances in which the minimum use of non-domestic materials should be permissible."]
[]
["Non-domestic iron and steel materials may be used if the cost of such materials do not exceed on-tenth of one percent (0.1%) of the cost of the utility relocation. "]
[]
["In addition to the aforementioned exclusion, 23 CFR – 635.410 allows inclusion of foreign iron and steel products if the cost of the “Buy America” compliant materials will cause the cost of the compensable utility relocation work to increase by at least 25%.  There are two acceptable procedures to document this determination."]
[]
[1,"If the utility owner will use a contractor to perform the relocation work, demonstration of meeting the 25% excess cost requirement must be accomplished by receiving two separate bids each from at least two qualified contractors for the work.  Requests for bids from qualified contractors must conform to 23 CFR – 635.410(b3).  One bid from each contractor must include a cost of performing the relocation work using “Buy America” compliant materials and the other bid must include a cost for the same relocation work using foreign materials. "]
[]
[null,"If the bid with the “Buy America” compliant materials is a least 25% greater than the bid that includes foreign material, then the contract can be awarded to the lowest bid based on materials that are not compliant with “Buy America”."]
[]
[2,"If the utility owner will perform the relocation work with its own resources, demonstration of meeting the 25% excess cost requirement must be accomplished by receiving two separate bids from vendors or manufacturers listing the cost of the “Buy America” compliant materials on one bid document and listing the cost of non-compliant materials on a separate bid document."]
[]
[null,"The utility owner will take the cost of the “Buy America” compliant materials and use it to create the total estimated cost of the relocation work and will do the same with the cost of the non-compliant materials."]
[]
[null,"If the cost of the relocation work with “Buy America” compliant materials is at least 25 % greater than the cost of using materials that are not compliant with “Buy America”, then the non-compliant materials may be used."]
[]
[3,"When Are “Buy America” Requirements Not Applicable?"]
[]
["“Buy America” provisions shall not be applied to utility relocations necessitated by a Federal-Aid transportation project where the utility relocation is not eligible for reimbursement."]
[]
["While “Buy America” regulations must be incorporated into all federally eligible transportation projects and some of those projects have utility reimbursement included, the utility is required to meet “Buy America” and FHWA and ODOT recognize that certain materials may be excluded from “Buy America” provisions. "]
[]
[]
[3.1,"Materials"]
[]
["For utilities, the following materials are not subject to the “Buy America” regulations:"]
[]
["·       Assembly materials"]
["·       Attachment materials"]
["·       Miscellaneous electronics and hardware"]
["·       Encasements"]
["·       Fittings"]
["·       Associated materials, including spare materials, required for maintenance"]
["·       Materials associated with temporary utility relocation"]
["·       Materials necessary to repair equipment that was discovered or damaged during construction and requires immediate action to restore to safe condition or to minimize adverse public impact"]
["·       Existing utility materials that are relocated from one location to another within project limits"]
[]
["The following definitions of materials that are not subject to the “Buy America” regulations apply to utilities:"]
[]
["·       Assembly Materials (miscellaneous steel) – The collection of miscellaneous materials used to fasten, hold, attach, secure and/or assemble materials including but not limited to nuts, bolts, U-bolts, screws, washers, clips, fittings, sleeves, lifting hooks, mounting brackets, pole steps, clamps, brackets, mountings, straps, fasteners, hooks, pins, braces, disks, clevises, couplers, swivels, snaps, crimps, trunnions, dead-ends, compression swages, and other miscellaneous materials used to assemble."]
["·       Attachment Materials – An item or material that is not an integral part or permanently attached to the pole, pipe or valve.  Attachment materials include but are not limited to cross arm bracing, insulators, avian equipment, miscellaneous hardware (defined below), fitting racks, ladders, encasements, guy wire, strand, conductors and tubing 0.75 inch diameter or less.  Cross arms are an exception to this rule and do not qualify as attachment materials."]
["·       Conductor – A material (specifically wires and cables) that allows the flow of energy including electricity, heat, data, audio/video transmission, etc.."]
["·       Encasements – Include cabinets, housings, boxes, vaults, covers, shelves, and other items used to protect or house equipment or miscellaneous electronics."]
["·       Fittings – Individual parts used to join, adjust or adapt a system of pipes including but not limited to, elbows, tees, wyes, crosses, nipples, reducers, end caps, couplers, o-lets, transitions, connectors (steady state, seismic and flexible), unions, mechanical flanges (not permanently affixed to pipe), bushings, ferrules, gaskets, O-rings, plugs, or taps."]
["·       Maintenance – An action or application of materials necessary to keep a system functioning safely and at optimal capacity; general up-keep."]
["·       Miscellaneous Electronics – Manufactured products or assemblies consisting of many components such as electronic equipment, routers, switches, radios, processors, power supplies, batteries, antennas, splice cases, pre-connectorized hubs and terminals, and cross-boxes."]
["·       Miscellaneous Hardware – An assembly of small parts that are compiled to form a finished product that is often used independently or as an attachment material, including but not limited to, transformers, locks, switches, cutouts, regulators, gauges, meters, barometers, strainers, filters, pilots, arrestors, insulators, ball bearings, dampeners, needle valves, bracers, pipe supports, actuators, motors, and pumps."]
[]
["In addition to these materials, “Buy America” does not apply to temporary utility relocations that are included in ODOT’s reimbursement process.  "]
[]
["A temporary utility relocation is one that is needed to allow the roadway construction to proceed, but is not required to remain in its relocation as a result of the ultimate roadway improvement.  A temporary utility relocation can also be established if the utility relocation plans require that the steel or iron material used on the project either must be removed at the end of the project construction or may be removed at the project contractor’s convenience."]
[]
[4,"“Buy America” Certification Process"]
[]
["FHWA and ODOT desire a process that provides reasonable assurance that utility materials subject to “Buy America” requirements are compliant prior to permanent utility relocation installation.  It is not, however, the intent of either agency to stipulate an overly cumbersome process to demonstrate compliance.  The utility owner will bear the responsibility to document that the appropriate materials meet the “Buy America” provisions detailed above."]
[]
["Under ODOT’s Master Utility Reimbursement Agreement, the utility agrees to fully comply with all Federal “Buy America” requirements applicable to this Federal-Aid transportation project that contains utility reimbursement and to not incorporate into the utility facility relocation any materials, supplies, parts or equipment that do not fully comply with all “Buy America” requirements."]
[]
["The utility shall provide to ODOT copies of all certification received when the utility submits its relocation billing for reimbursement.  The utility agrees that ODOT will not pay for any relocation if it cannot prove compliance with the “Buy America” requirements for Federal-Aid transportation projects.  The utility shall repay ODOT all funds paid by ODOT to the utility in the event ODOT subsequently determines the utility did not meet the Federal “Buy America” requirements."]
[]
["Non-Compliance.  The utility understands that ODOT will not monitor the utility’s relocation or the utility’s compliance with the federal “Buy America” requirements.  In the event the utility completes its relocation but is unable to provide all necessary “Buy America” certifications, the utility may, at ODOT’s sole discretion, be required at its sole cost to remove all non-compliant or non-certified materials and install compliant materials.   "]